﻿using System;
using System.Collections;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data.SqlClient;
using JobSiteStarterKit.DAL;
using System.Data;

/// <summary>
/// Summary description for CommonTask
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class CommonTask : System.Web.Services.WebService {

    public CommonTask () {

        //Uncomment the following line if using designed components 
        //InitializeComponent(); 
    }

    [WebMethod]
    public string HelloWorld() {
        return "Hello World";
    }
    [WebMethod]
    public DataSet GetCountry()
    {
         DataSet ds = new DataSet();
         using (DBAccess obj = new DBAccess())
         {
             obj.CommandText = "JobsDb_Countries_SelectAll";
             ds = obj.ExecuteDataSet();
         }
         return ds;
        
    }
    
}

